FaYTDSummaryWork

Logical Entity Name | FaYTDSummaryWork
Default Table Name | FaYTDSummaryWork
Physical Only | NO
Owner | dbo
Definition |
Note |

FaYTDSummaryWork Columns

ColumnName | Domain | Datatype | NULL | Definition
FaYTDSummaryWorkID |  | int | NO |
SchoolName |  | char(50) | YES |
PellID |  | char(6) | YES |
BatchID |  | char(26) | YES |
FileImported |  | char(60) | YES |
UnDupRecip |  | int | YES |
TOrig |  | int | YES |
OrigAccept |  | int | YES |
OrigCorrect |  | int | YES |
OrigReject |  | int | YES |
TDisb |  | int | YES |
DisbAccept |  | int | YES |
DisbCorrect |  | int | YES |
DisbReject |  | int | YES |
Comment1 |  | char(3) | YES |
Count1 |  | char(7) | YES |
Comment2 |  | char(3) | YES |
Count2 |  | char(7) | YES |
Comment3 |  | char(3) | YES |
Count3 |  | char(7) | YES |
Comment4 |  | char(3) | YES |
Count4 |  | char(7) | YES |
Comment5 |  | char(3) | YES |
Count5 |  | char(7) | YES |
Comment6 |  | char(3) | YES |
Count6 |  | char(7) | YES |
Comment7 |  | char(3) | YES |
Count7 |  | char(7) | YES |
Comment8 |  | char(3) | YES |
Count8 |  | char(7) | YES |
Comment9 |  | char(3) | YES |
Count9 |  | char(7) | YES |
Comment10 |  | char(3) | YES |
Count10 |  | char(7) | YES |
DateAdded |  | datetime | YES |
DateLstMod |  | datetime | YES |
UserId |  | int | YES |
ts |  | timestamp | NO |

FaYTDSummaryWork Primary and Unique Keys

Key Name | Key Type | Keys
FaYTDSummaryWork_FaYTDSummaryWorkID_U_C_IDX | PrimaryKey | FaYTDSummaryWorkID

FaYTDSummaryWork Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaYTDSummaryWork Check Constraints

Check Constraint Name | CheckConstraint

FaYTDSummaryWork Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaYTDSummaryWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaYTDSummaryWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaYTDSummaryWork | NO |  |  |

FaYTDSummaryWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaYTDSummaryWork Data Movement Rules

Name | Type | Rule Text/Value